SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002354s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405416 LIMIT 1 [ RunTime:0.000798s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405416 [ RunTime:0.005481s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118450,431222,965716,506951,884075,103772,251687,116009,956014,628320,764916,211385,536361,40747,174972,410160,513101,502239,246187,696095,332938,985298,292405,943044,592439,113172,161878,410484,75015,481321,328661,51622,187208,250761,521904,798153,860902,948734,877688,814151,462010,242563,297079,544282,919248,470286,708441,820803,240024,864603,607173,973341,579433,338819,141304,177545,164102,520009,500595,70325) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003854s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]