SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025041 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025041 [ RunTime:0.002492s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047864,56111,680066,942374,492808,792978,911523,66253,276758,435856,743537,698833,452308,879707,247955,923203,413345,716301,901167,166333,197317,518187,21628,1012629,178936,954676,1010204,283992,119944,214129,947505,189869,741518,194227,675135,273979,1030641,309031,508039,720989,166614,916526,377157,325988,639587,799613,446621,55209,949095,951008,1013861,922145,803182,302422,761207,719103,604963,799295,308064,811780) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]