SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 49431 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 49431 [ RunTime:0.003219s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (937707,75120,231674,138420,123402,22416,535873,671921,132341,928228,20968,991616,937901,305750,172086,495409,602124,796205,25384,239024,475327,116157,474265,431941,200424,746171,704783,3860,794948,18322,684497,217857,461454,466046,772999,130312,645641,704494,367720,736479,391850,909527,668819,134570,85918,317112,698807,145288,550601,335138,539243,1047964,413764,55225,322053,582411,989474,149374,419504,15211) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 49431 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 49431 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002979s ]