SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499038 LIMIT 1 [ RunTime:0.000462s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499038 [ RunTime:0.001456s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (654431,23537,102661,62911,536718,897089,1035938,905568,44744,126781,383450,105191,639856,844518,407817,293394,765001,304189,603626,216912,87324,25427,92335,945021,1015886,534735,730646,179563,619105,169702,942747,793323,885863,296325,712864,162534,346343,960140,990789,211160,483606,708786,257839,876317,58870,650498,462550,848107,239319,241550,245205,978565,989273,349775,846928,199793,112803,30198,898132,1028177) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]