SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54210 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54210 [ RunTime:0.002126s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (507934,817923,396268,940391,254583,320358,903826,480604,124099,23839,926117,15493,592931,252961,180761,118883,589676,391163,210362,220611,467063,355032,458324,677124,369701,727070,722284,672602,305221,655888,189852,813602,903145,496529,725370,290818,202983,237283,171929,988265,648691,529458,82750,30705,837293,316520,61862,944431,465504,507413,871995,341957,831182,231953,376001,1019352,720862,426807,238307,579266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]