SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018681 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018681 [ RunTime:0.001888s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (347903,853094,844572,773643,1007437,730866,575711,238746,1042747,697995,886884,371484,295638,564,900710,766448,970495,210341,360337,762622,330302,315217,753893,820028,635100,408584,279189,1032473,340559,864608,151573,804325,673983,300402,2872,998115,512664,280652,548583,263887,3039,737750,354725,663835,629930,474230,1018450,636305,68448,474967,324542,644263,394810,389430,193674,563361,27037,41806,393073,695720) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]