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` = 341581 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341581 [ RunTime:0.002275s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576179,229446,430729,180744,881886,813360,431,624482,712064,764825,418600,743962,549295,280405,1019482,678943,654937,864643,949438,328844,639093,756537,7557,272533,52560,637134,704033,859228,703913,731653,980573,876408,340972,230447,685672,150409,490665,565544,257298,168438,197299,797122,373909,950788,272785,387773,52773,609211,481371,837856,847668,676467,63371,577212,470012,905172,312799,211443,22751,388576) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001063s ]