SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485812 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485812 [ RunTime:0.001558s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (601885,219386,711297,420033,363983,504481,51377,240040,725383,855204,415728,676517,921320,278757,38963,102109,995256,433430,119974,556074,536101,81386,60926,252563,177480,234168,862665,414119,1028191,634516,59264,704112,1032075,58299,305154,599368,207707,540997,34818,779136,717190,642515,969095,469272,899990,459592,592995,140886,916072,986890,488098,59510,583300,628378,691273,129083,418736,984369,352714,145255) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003500s ]