SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519306 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519306 [ RunTime:0.001567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (559490,566360,750780,729211,602797,399042,45792,358417,41774,1040084,987196,853933,824903,336177,450834,837830,745047,834802,651810,197615,82929,303939,775265,305129,753185,660876,339315,193701,909972,400730,24792,987152,21843,258065,150087,366895,175753,5393,692582,598192,742705,639412,140864,218497,715593,1038053,512289,599941,43767,34833,980701,1027187,778084,182402,306317,556116,601260,686621,321976,582098) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000951s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519306 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519306 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]