SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429449 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429449 [ RunTime:0.002269s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (256757,501530,1048154,890442,646015,98816,355279,745756,989385,500246,742185,215725,724217,786166,974441,119465,147313,836797,635576,267521,349343,516301,171568,587771,988210,862839,514208,993211,592235,904435,809834,974825,8342,408962,299105,221670,341470,732586,478279,115631,427057,892486,26989,682594,427290,64301,512280,120924,920355,67856,399651,511726,981751,443726,732665,49787,938743,513126,307445,933961) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429449 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000616s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429449 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000978s ]