SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010299 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010299 [ RunTime:0.001771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (673705,720421,230286,466079,976738,272438,408404,368618,793944,78974,782023,895525,404980,108195,645337,378501,914173,725103,939109,789615,524628,870964,456563,133166,347129,374115,612448,842264,496615,1031591,706272,562492,829796,106389,412838,309885,11226,330518,26796,528284,636665,605134,263543,580027,640889,91129,414811,795992,413461,487380,327052,747406,15623,35186,344682,303490,480400,515003,142970,202582) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010299 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000650s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010299 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]