SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000945s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108424 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108424 [ RunTime:0.002530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (319736,567483,41836,829768,475628,292316,330709,377559,851310,465502,227503,984923,371778,117883,347320,881690,428336,256085,305549,773183,377129,765347,419902,886139,496060,517404,688322,955290,1029461,528541,181499,446891,264143,1041807,1048159,134477,34260,168638,1026355,168032,160187,428708,768521,958572,609074,658096,52302,665289,619856,802051,322850,537787,745047,123278,222185,711868,674739,838507,99882,867678) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108424 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108424 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]