SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475443 LIMIT 1 [ RunTime:0.000628s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475443 [ RunTime:0.003321s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249640,391190,974970,79810,247355,547007,650472,521998,856902,238140,138044,691933,551197,832308,541028,222307,909809,878899,143377,193043,847940,944262,311894,779442,300695,270183,168192,442237,512925,486001,279431,295191,241107,482701,335014,40352,824534,62189,365859,943214,44241,909215,299350,102412,771464,468435,700488,72636,201831,819251,871071,959994,298745,236112,903406,964434,981752,691184,1019920,1044370) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475443 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475443 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001278s ]