SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001820s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520805 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520805 [ RunTime:0.002692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (103127,1020133,378462,844344,171489,410266,238732,730105,1028595,515982,971523,253718,963520,821982,84655,452451,985300,912919,549469,110558,55793,958765,578157,820565,321107,516458,450474,113990,541206,19850,179366,314283,894274,303326,202468,16980,534797,823376,105361,809325,945813,746667,116997,59199,462085,722601,624608,610120,551266,912084,771440,862343,578517,242297,358813,181996,1030112,567168,394874,302941) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520805 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520805 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]