SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 315860 LIMIT 1 [ RunTime:0.001578s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 315860 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (931794,141890,583692,729974,154110,645902,596867,410900,966426,637300,651104,622764,1040721,960069,189123,394029,1018711,265605,993167,14378,70505,170235,699715,481685,968328,725732,248676,788280,587946,132298,847712,948075,1021277,511633,585891,139922,116096,1027332,541923,860157,382269,26381,229574,787889,352930,616962,564385,454287,554299,129291,805399,478600,2210,873770,265679,266730,208023,250134,788484,583221) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000943s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 315860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 315860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000403s ]