SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391512 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391512 [ RunTime:0.002650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (645568,528440,364970,769289,1042991,483159,598515,807580,813536,999733,790374,909758,951162,903786,695981,121641,974000,713727,628047,828589,298236,187601,914843,434712,453197,912173,581411,664551,213160,691976,722526,70744,285967,10245,310968,89279,755336,418935,134069,24346,792246,1006641,142381,431931,848038,12549,246654,445972,883253,158708,977746,684504,317565,588966,813893,943975,1012159,208528,394399,828797) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]