SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529805 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529805 [ RunTime:0.001577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (645132,224497,662579,288047,548629,645654,447241,948067,679719,681130,800709,932721,61393,997990,680634,837079,1019232,500735,521384,799735,661402,277280,1035388,1032759,726097,919768,7167,189059,817488,554434,581771,495849,160739,118475,548713,127138,435413,68408,500650,78670,451275,548803,251274,362102,947674,872695,1008915,408398,559789,614088,453553,215972,997891,716756,15329,860648,430711,67470,501114,599910) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529805 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529805 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]