SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503259 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503259 [ RunTime:0.002323s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (434480,1027878,992676,764053,413200,918151,347400,394252,274424,695320,700964,1042577,312572,891846,950984,924438,201541,82546,654960,53904,577314,903654,312873,192756,444478,269968,365410,219115,641409,756424,700326,454865,196247,863450,823657,901474,3626,535712,942951,1048550,532389,650942,431271,850277,5370,11291,714813,544912,601853,291045,314010,722151,171788,689522,462287,1046441,635221,219781,910054,130423) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503259 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503259 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002038s ]