SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040701 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040701 [ RunTime:0.001487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (321393,44720,488279,883446,694143,274139,350636,110606,65655,172700,111573,63883,180042,159590,951726,474904,258511,498005,959985,225474,614164,159800,172053,510580,860889,613631,601663,562765,470190,918048,763397,1023843,558643,1012600,492351,980055,6614,820071,212026,512481,964772,99281,187972,737660,571186,647003,729531,675262,12238,955589,697510,679074,95576,405135,428159,814620,74279,922142,92110,773619) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]