SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 395860 LIMIT 1 [ RunTime:0.000879s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 395860 [ RunTime:0.003903s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269888,746786,455446,135377,1003072,30189,707259,21429,409459,915514,626732,302410,762527,976203,573110,784450,388097,449284,442581,533066,142794,822882,611979,634538,333103,542880,435187,447960,209659,636345,190656,581042,526785,755170,354122,265459,671685,821791,588790,780546,446011,988463,495543,754148,710309,925971,396431,414552,49480,71548,859925,76432,372462,461124,172239,874067,70115,106423,1033666,620479) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 395860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 395860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]