SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567728 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567728 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (557352,572505,942885,269539,763875,2216,979782,736685,165660,88550,949672,150801,793499,864795,534320,441452,909930,112082,128528,120638,824430,993613,1030909,647775,1019475,784121,544384,568434,592537,608327,289779,968701,437413,504043,102383,644458,297660,99907,684382,530842,552615,144342,638879,868037,379495,729288,221617,603680,85503,1001035,103669,666670,825865,414146,678374,833253,953641,346965,815908,629747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000836s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]