SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292443 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292443 [ RunTime:0.001639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (302312,359285,131048,349465,1030547,983450,91231,883970,1035033,404942,625452,647965,705446,453239,921940,24501,413718,581355,908127,343506,520264,580809,593479,92910,889575,755664,749649,384841,662040,664039,592073,920011,394946,815598,36096,640955,674088,464160,428268,181905,874404,213008,487603,420354,454103,981890,961300,63648,1002147,389686,139647,46986,492443,177181,174143,671258,327642,217979,803781,896846) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292443 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292443 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]