SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001843s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521234 LIMIT 1 [ RunTime:0.000633s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521234 [ RunTime:0.004207s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406692,901311,287502,540220,498360,657157,36187,193052,995081,173297,456882,582768,426727,803216,231442,135050,651534,612638,359886,967525,714570,871724,195640,650060,282426,299682,498361,1018212,1048348,502018,988206,421446,468461,518358,618132,219523,991427,535780,648175,266188,430988,644676,110104,62780,653440,164514,213150,1009995,506283,467451,662227,861885,758225,550652,573542,348075,1027673,791015,72639,950201) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001545s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521234 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001846s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521234 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]