SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510941 LIMIT 1 [ RunTime:0.002271s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510941 [ RunTime:0.001167s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014323,281207,377122,435968,697326,889094,776961,287332,442257,604987,508654,868315,149117,712870,336975,45455,37841,435625,532179,70644,226038,909771,62241,529575,351293,188359,626903,407211,486147,56199,887719,43716,323780,382771,293701,880051,945923,62958,862909,529407,269510,670153,298233,551495,609605,955044,277826,753454,846022,383070,765462,702677,331710,250216,354599,106573,268415,952878,863696,615898) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004309s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]