SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 344243 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 344243 [ RunTime:0.001949s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (646721,1008860,434764,148617,46118,306471,794780,15455,831898,59943,867694,107796,383672,474712,974174,221414,731507,144996,83634,79029,402252,458600,503585,394595,678259,483361,50637,188199,140764,126408,475569,818756,1032126,752022,83343,495375,90407,932687,881058,126368,493815,659411,179866,810032,539131,491742,394249,102789,351977,1025727,903517,580144,842375,194103,321317,551313,936527,213527,740100,217276) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 344243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 344243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002811s ]