SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013117 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013117 [ RunTime:0.001906s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (297222,183844,701739,241047,463933,111989,304195,358468,639501,690551,208616,63684,735229,430295,710807,932783,278102,192254,645937,193433,651647,69098,254252,581868,665212,204864,474150,801132,580974,362753,428019,860730,257991,529639,76172,179084,862973,817498,672052,919615,317414,563125,215671,877018,684604,687330,645573,846932,932755,931575,298401,554361,722791,633537,931136,855469,491773,442291,433187,357622) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000559s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000685s ]