SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 71801 LIMIT 1 [ RunTime:0.000631s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 71801 [ RunTime:0.002662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (430677,10976,1040916,897105,178899,221603,395221,372867,834801,498659,343909,436682,918521,252241,1009081,1018440,312955,565387,350113,273258,271690,437297,997833,254247,594106,1015329,819982,887502,258928,999836,107136,166040,86008,781966,569147,492847,426329,87289,647984,545579,930433,947180,247752,779716,440038,129660,964741,47277,913007,42735,186182,874937,285514,324727,609676,345802,550337,452890,634846,879909) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 71801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 71801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001714s ]