SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003519s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 361099 LIMIT 1 [ RunTime:0.001143s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 361099 [ RunTime:0.002673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018272,1002791,903557,907277,371496,192249,827830,414406,581064,252783,721122,166151,648279,570703,1002929,562255,768229,880723,268090,1010122,449362,75907,393872,137513,228162,876383,436147,215144,145302,353982,659044,855133,725893,589862,329197,574037,146813,279644,917418,48482,1018936,850054,31262,264322,769265,821383,134668,531571,363526,969757,1041450,19392,787790,395443,520746,887682,146767,566987,712067,85582) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 361099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001526s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 361099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003648s ]