SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 342978 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342978 [ RunTime:0.002450s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (32685,211547,274202,517589,296164,769570,1020131,1022182,822393,415498,1044003,512402,614714,227795,599779,606635,599818,892914,546033,820137,995008,818752,812037,271075,755304,802056,578409,75247,821524,800814,219528,716324,481285,284760,481739,403236,807666,564270,854144,169223,938706,581094,1041277,332309,466991,911345,323923,835283,572133,288384,751395,949247,388264,129839,557544,662799,249538,135555,280555,158351) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]