SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506916 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506916 [ RunTime:0.001586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (562189,186724,1024034,696480,14221,250494,236901,970234,971557,942607,788155,656416,790261,1033553,284292,751489,671615,634541,326255,99524,492524,825471,497435,573265,627110,375764,149593,239396,875236,248852,1009873,274701,1006304,866261,830601,1039511,379479,321629,958284,309844,263443,558752,98423,59960,426850,780648,531298,281496,508081,123463,89821,771429,26433,149848,1043665,1022250,929374,1044492,382242,1017635) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]