SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291052 LIMIT 1 [ RunTime:0.000475s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291052 [ RunTime:0.004403s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005031,936643,414323,782506,659759,253915,143421,894203,929024,481224,870348,406566,68501,793945,835258,947470,972562,966206,642464,912468,925451,857830,247680,672356,679885,208541,303148,508991,616022,589577,6799,394894,474922,987212,22637,708116,583549,49947,158096,174727,482766,547160,607916,434859,124899,211252,691786,388773,769550,490837,856672,849105,450569,551402,870149,357477,338911,293498,772168,689768) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.013390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291052 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001836s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291052 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004290s ]