SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31 LIMIT 1 [ RunTime:0.000281s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31 [ RunTime:0.001673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (497831,93630,365346,790556,905570,40703,931838,748494,981820,62902,495915,774876,352168,833533,110445,245049,641788,608549,189649,689104,539801,973949,538266,29485,57661,366160,1002119,533580,255137,389927,995634,25460,557886,411422,1047847,585436,614575,130575,186133,509808,273100,59591,837371,223286,25205,569050,211472,714390,623888,996008,491583,200232,41481,460688,683020,564231,61622,394984,235992,166348) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000933s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002454s ]