SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 306051 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 306051 [ RunTime:0.002140s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (452074,282975,251898,879988,901984,899045,1044290,276361,84318,723283,461476,346747,865942,643707,185726,491768,154659,938649,885614,995381,832390,170229,1016325,857787,366788,987166,564496,159021,309612,594995,501508,917845,1008488,705573,494576,693395,566618,318485,218576,10167,978264,264508,326391,439762,199512,744214,837663,576369,388776,105965,924244,802036,634754,149766,37302,742235,751393,645760,1010120,332940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 306051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 306051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]