SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 382343 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 382343 [ RunTime:0.001757s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40956,678753,430074,848299,298642,724465,378315,683419,407377,933096,1003417,466430,595085,20556,365740,397593,1008988,412742,1042968,660720,660289,607101,595742,210606,966015,446413,577488,336332,902892,545089,938144,524956,432566,864115,347974,56217,891296,170940,863110,831009,15030,594207,822652,715164,850606,411014,908212,519792,944049,765532,464294,442920,341628,350219,410834,468154,734529,137837,109827,676840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 382343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 382343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]