SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406839 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406839 [ RunTime:0.001923s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414738,1033728,883844,926749,802090,413086,234457,370120,37386,23848,454192,179812,392543,846509,418038,357952,834474,183476,987016,58920,780728,890211,996845,404749,295120,908685,170964,52773,935524,647526,1010531,165658,488159,1035029,129731,636264,134226,327869,536875,314071,660112,642630,755008,645958,982951,52548,201128,864806,603596,27913,235833,250926,30548,327512,527459,681984,279789,572813,38488,156061) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406839 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406839 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]