SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001409s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584129 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584129 [ RunTime:0.002831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (52257,631205,232571,438131,954283,343040,941873,679681,543426,905654,828510,269104,408140,806501,201799,397683,419161,192869,121850,778458,797826,633621,324520,927186,1015440,606850,573369,831050,230860,551553,130160,164962,141126,248501,469518,175837,65826,242561,603430,661058,431241,489672,486383,35597,553123,703517,372786,262399,783283,974038,981327,692116,308645,867151,861774,452341,836066,714380,235150,592189) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001811s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584129 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584129 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001155s ]