SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528639 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528639 [ RunTime:0.002662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (945551,495310,368847,560857,82693,818096,13840,288384,353172,42876,461840,691384,541808,327866,124803,580085,1008415,698795,577862,632073,642228,1028466,559831,39313,551223,509745,281043,676509,636146,911345,716735,467415,351513,779184,578224,808485,977131,999942,391095,813516,716941,145445,716348,895714,107051,159734,462693,905616,747127,136599,456046,213185,341825,635409,284164,387144,774263,462365,837123,1025187) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528639 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528639 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002013s ]