SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50527 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50527 [ RunTime:0.001681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (279877,391059,171139,1015847,754950,776700,378203,41876,136979,620003,544270,1028084,518663,792463,16622,318138,354821,700373,772981,884031,814698,713343,8665,655286,197630,351016,977908,45879,324089,39581,176201,138279,415015,972290,170728,1024325,834615,276453,111988,948601,515678,936766,16701,290091,39090,464478,471965,684417,207453,872699,761733,870015,958213,278859,290580,1035718,435791,296596,129950,814555) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50527 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50527 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]