SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 690311 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 690311 [ RunTime:0.001531s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1007055,732846,946488,598784,710352,1040609,689458,936916,474369,381796,620156,869672,546070,651069,307534,58409,418334,813276,513617,655719,1024317,101248,372671,794258,422182,220101,617594,268235,344426,229741,72775,68117,364244,331898,884672,447328,51355,528020,620756,959165,906163,550343,403883,830262,838288,825404,685607,906285,570095,299341,774886,317868,1027596,584499,930389,105973,463218,354760,894363,980360) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 690311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000661s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 690311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]