SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 653610 LIMIT 1 [ RunTime:0.000466s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 653610 [ RunTime:0.003080s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1038026,851980,245324,836322,221872,572395,355553,658268,385658,542100,387186,401752,58691,6909,161113,393398,912280,997142,631835,265616,454511,770353,529688,544733,226702,230587,1033127,442856,851235,732318,382429,249569,561045,471109,631965,79104,684235,364223,914621,1923,64927,194580,705850,558019,970716,732226,281522,1048668,646165,480746,402380,560828,482124,367492,1017414,390960,589791,136374,1006315,458124) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 653610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 653610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]