SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014130 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014130 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (639281,739736,55748,1013698,350934,332776,278800,204380,400908,149078,910078,109680,758894,856068,1013990,156567,68659,703614,613022,507701,352030,492574,49109,228735,645230,572888,730350,20610,176290,424958,515783,1028988,310335,631766,685305,961631,606230,801362,343047,326520,193249,216544,524363,481431,141562,729008,837007,198527,196748,246090,813447,139318,328025,233462,763654,244391,768429,621467,1026356,925011) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014130 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014130 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]