SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 469716 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469716 [ RunTime:0.001869s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (674896,767253,477823,811187,759808,445763,905705,107656,359680,269954,138415,42991,500936,423790,920007,992915,834048,1038894,295279,694349,639457,112081,989650,374685,394941,792911,122096,1020037,770839,57069,846327,161957,213840,23500,487653,1023688,341300,900749,671145,958236,115752,494617,69955,410106,946373,891104,472018,350833,536997,183072,800690,900116,1013470,488531,917890,4698,336749,544234,640725,754067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469716 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469716 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000684s ]