SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002034s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437211 LIMIT 1 [ RunTime:0.002418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437211 [ RunTime:0.004591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (446261,777835,836999,497530,708300,920759,822302,162245,718167,63289,483828,820386,769815,993739,648260,895146,592521,595765,59656,402933,539961,826078,1017447,562505,115081,109478,117685,556305,944567,1044165,104889,733977,77455,105964,651417,4570,981868,475163,847566,389772,558961,290119,134237,1034787,1037031,235821,864189,992979,256020,362014,619887,129077,796252,789327,686101,536113,103007,68115,50388,691069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001948s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000689s ]