SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294540 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294540 [ RunTime:0.002535s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (435582,21439,275375,285839,974453,622604,9956,528268,577287,376352,727888,71768,414580,162417,693603,299398,934588,668308,620480,72922,238562,409210,968487,357885,641059,124275,309327,441234,254998,381176,1020247,274016,985757,447828,703838,791320,654428,847029,416113,819940,820618,309891,745486,17245,389603,857272,664113,122111,123046,711223,221900,702440,795703,464588,170536,204415,514573,579206,24666,85651) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004679s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]