SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 315038 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 315038 [ RunTime:0.002754s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (183677,423717,814034,206028,216702,178479,556221,1027188,546999,929412,327374,729868,147601,173267,747502,563142,610634,113160,797725,2963,29668,410907,681388,738644,804775,617035,660046,328911,1025909,194399,306881,608489,32586,963881,232728,885669,945879,140593,692398,96362,230358,222458,171630,323775,118690,132929,720489,194942,617599,440400,86592,666606,856615,13393,131040,590548,756602,51295,175961,3181) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 315038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 315038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]