SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423518 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423518 [ RunTime:0.003206s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (674815,54903,819502,525381,126869,1008127,177314,731253,437675,25568,643450,362686,917382,428893,461783,82089,285218,1048009,130613,878391,453563,849542,967075,568011,945416,452748,540136,183096,586300,15073,993938,796850,925913,503152,620597,130497,928694,662037,171504,977797,621910,171685,693052,601176,294097,653908,102644,590132,1038438,1006878,535203,958905,989011,861810,907736,912838,55499,184297,293494,876219) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001706s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]