SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503521 LIMIT 1 [ RunTime:0.000876s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503521 [ RunTime:0.002481s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (161101,263125,196102,275452,295790,651311,9417,415206,976566,322431,348877,589796,545550,682453,410148,874788,30478,195065,222004,802186,186331,631193,706925,982823,886156,207695,129082,856262,969966,413628,567885,679078,437327,264100,865302,610102,781031,857531,500370,946341,794271,525907,120503,456318,483201,888604,314687,571369,558575,501606,47087,245531,529466,1011940,293164,502978,589723,522737,875348,784297) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503521 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]