SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001637s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107023 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107023 [ RunTime:0.002059s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107412,808017,226700,166135,481845,1009,874946,715881,310651,126097,514040,59348,946109,561421,656527,35394,4497,544272,850403,1006646,713638,604180,797994,381756,186084,118391,601472,915119,522642,147439,395057,448598,583203,326830,273981,995615,707224,461157,836016,909608,286732,394439,586440,219065,1000997,764223,80806,91305,360704,862231,977318,540067,828745,846493,433540,421020,209884,667255,366125,680496) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001769s ]