SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037040 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037040 [ RunTime:0.001073s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (500313,310473,820789,821362,147257,180670,222088,853393,183168,891266,761876,85375,947713,505111,326594,390544,280718,969602,628069,89052,314630,748133,894817,997350,451429,898860,279584,332154,309088,865535,578071,591391,456880,811848,443034,77946,362160,234775,461618,827133,411436,360356,45669,538595,424369,571347,919225,472210,373001,827924,223990,409375,777754,358321,561299,242158,822272,604382,759367,529351) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]