SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001680s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 170080 LIMIT 1 [ RunTime:0.000497s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 170080 [ RunTime:0.002257s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1007732,1035166,428721,834192,485124,354441,343206,752537,95136,878742,680969,543379,161524,750281,524901,325629,602649,676193,4005,498781,160023,426508,540115,63536,893147,141919,695513,936738,354224,470335,449021,417750,561795,744273,258604,197743,1017397,518324,868347,104755,272548,154091,640092,489784,205705,394083,573733,1001600,93277,437518,870003,760141,163299,109991,1009273,120821,104942,446067,1035566,136278) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002724s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 170080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 170080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]