SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048733 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048733 [ RunTime:0.001569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (897246,731771,910781,368991,130029,394163,856379,918874,627429,104479,607588,1037231,3153,727268,900207,826562,217883,825412,922087,194854,933012,168093,348327,65474,697409,829027,639620,318181,816929,573749,308589,828011,60899,919685,187757,120159,791027,258307,449468,977163,181727,565432,870081,574009,65165,653415,196513,188787,566841,387735,766877,286553,237525,562237,110181,995510,288854,788139,437939,992665) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048733 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048733 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]