SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014577 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014577 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (788639,1019220,822250,698023,250301,840140,522706,627462,595820,535630,20845,339305,447407,452167,446483,380410,678307,940058,561813,187864,488230,951941,463895,401957,983199,329039,123378,594770,637142,711516,1043068,898481,577199,845433,445739,382353,404978,72668,61479,752867,646932,837904,625941,796074,559098,404380,787747,884110,362825,39812,884953,337205,1016057,634277,515809,393994,142420,576618,693120,811775) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014577 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014577 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]