SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003455s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019689 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019689 [ RunTime:0.002593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (790803,412804,185858,104020,825557,849182,245812,248455,807912,377054,712021,389473,453883,637959,133004,219890,300214,1042560,524031,950011,44754,999775,455136,222441,498622,778372,75293,801460,894427,294581,721031,793937,198057,592293,584258,461661,656453,140685,770230,368433,561527,185527,666710,118673,780938,881254,931780,55667,832650,720808,428869,796877,441931,858601,614307,34698,336262,851767,180652,1047006) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019689 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.006281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019689 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]