SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002737s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481936 LIMIT 1 [ RunTime:0.002029s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481936 [ RunTime:0.002694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (641164,112874,861185,633964,61294,833887,397771,286341,98742,1020703,178638,473121,805261,505518,635648,676766,108961,460945,55116,466262,300922,652554,706040,863205,997157,1018601,204178,951107,738093,657394,785134,488587,856755,906877,429981,571231,1007707,873168,353459,531796,695998,86540,7865,43473,633269,1038098,385842,73643,167227,253240,561103,48579,461763,515152,480805,1026345,504590,5994,220294,402944) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481936 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481936 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000706s ]