SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53497 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53497 [ RunTime:0.001699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (734852,587435,951560,783046,1038590,205722,557869,567390,1008308,365257,932350,355683,302133,220927,663068,900029,906758,782673,1047490,101994,469117,212473,807470,771010,571870,898726,916380,879884,1032003,575607,472666,790770,849636,712388,964190,812955,558727,401324,322956,339300,369272,569637,789026,705875,1025386,653386,56150,50289,200867,1046010,635371,158189,367616,383041,417423,888888,373884,853040,225431,895887) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53497 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53497 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]