SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591728 LIMIT 1 [ RunTime:0.000981s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591728 [ RunTime:0.002012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140949,879577,470876,1007258,185119,20173,584548,329280,418853,93583,1017871,474850,140055,434451,793035,50297,123229,622644,1048763,638527,207833,592387,280761,876193,158329,612018,506545,528193,845995,816380,169913,557807,515791,893478,144375,101383,380956,36526,742034,930492,728612,783483,546605,1023025,34416,459841,1040380,386578,702985,249319,183031,684922,362247,589293,655883,493451,228290,531152,491028,1047196) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001845s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000700s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]