SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196409 LIMIT 1 [ RunTime:0.000536s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196409 [ RunTime:0.002945s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (528801,402567,705181,1027388,904348,188347,947137,967973,455329,438747,317640,236814,394789,757927,626524,974009,466138,433047,644504,711418,574864,284847,539412,629489,196455,830903,169895,887593,100820,12307,1019907,710119,21484,537870,774847,731296,426440,938258,113722,1027632,890278,253114,1035215,353121,312088,818362,107682,708158,659785,204054,310305,809377,705660,491592,690306,765676,989761,96266,597778,736404) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]