SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488026 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488026 [ RunTime:0.001644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482041,484070,422014,684590,935207,838275,160703,127448,612805,93924,111975,770662,705906,173538,462213,504921,109242,5025,750092,721473,840444,173393,715918,610674,195177,638168,295871,602246,420746,931099,354721,112059,92362,73961,874481,763898,534564,949528,144493,20099,858455,203360,480686,252445,142788,324240,399536,700783,1017632,393195,466844,265734,917532,125613,576537,18463,849044,818343,1043926,948874) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488026 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488026 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]