SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801516 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801516 [ RunTime:0.005664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (834652,151277,326694,245584,413454,419717,340940,479515,851458,818371,437700,843383,990003,424944,423354,968861,793832,738229,551743,888519,244780,937226,831629,1009548,826641,19841,799046,440303,650417,959872,659620,773157,245516,431898,261453,829359,282973,533079,219494,1020563,935351,319131,201980,894436,419460,1033292,508870,38843,196793,944502,644596,692085,51341,1006100,440571,70169,928669,806966,39060,500053) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]