SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549746 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549746 [ RunTime:0.004212s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (268617,707294,74311,1039828,108539,864272,1030056,724482,108515,278356,772086,107781,178307,860536,612954,739436,771430,264229,604492,924685,421216,875522,781208,136403,448723,275128,335897,437838,911873,248445,873983,951086,452884,66984,235793,299494,30549,649891,224292,875989,82071,648509,1560,490516,413007,817093,297207,695361,937608,788480,751487,1048386,340561,418356,904927,108243,643629,142581,390513,1022873) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549746 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000668s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549746 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001495s ]