SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039777 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039777 [ RunTime:0.001497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (310067,217842,508527,301862,1030686,494556,980757,945146,803479,625675,663437,1010229,308249,827206,528764,331287,497108,354525,518184,747205,111420,969205,310139,944434,715475,990992,259099,537843,597724,860541,131651,253814,331683,1041522,96442,349297,135461,72692,600301,334894,763106,272034,702574,771180,255160,127156,195068,976359,133309,1001964,140655,554037,953008,773330,52694,804333,574641,792123,278274,347572) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039777 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039777 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]