SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002750s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 848039 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 848039 [ RunTime:0.001497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (291349,1014130,263740,881180,967611,476336,639813,728150,671153,200678,997190,780025,151658,325662,281407,395622,961635,179673,998791,1012030,715961,230093,472819,381546,768440,79563,687464,291927,579771,391812,140496,972818,604715,622819,466291,655348,224521,189846,820438,12079,653591,589330,1027867,901739,202245,179617,884605,547990,348439,515142,789460,914781,972772,135298,95200,1047270,702953,280120,10521,561051) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 848039 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 848039 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]