SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 80159 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 80159 [ RunTime:0.003110s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (932927,980727,408818,233645,49926,1039296,564949,13265,458379,604459,45468,264198,569097,411578,450972,482131,503062,453231,733151,243869,936900,561409,915851,114141,980771,822701,992446,236638,679916,981706,546946,521939,11453,524630,622713,858140,567321,255847,597846,112498,185885,15993,122554,805409,282508,662624,755274,562207,710504,685911,653820,702833,280482,776179,813290,931585,633804,14061,377693,632935) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 80159 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 80159 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]