SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445036 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445036 [ RunTime:0.004372s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (306558,799950,181531,590559,644435,812847,565600,58332,161970,270386,516591,151814,102665,277173,593973,830189,737920,714727,275227,456573,383166,901932,665585,122255,266112,240068,149153,104302,633779,966723,452628,838447,1011401,761140,22221,825353,493387,899784,427881,21081,65392,197967,424418,843161,887621,711713,735496,480655,362281,656134,715633,590994,583108,197861,792834,510872,442173,334454,692322,603596) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000395s ]