SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381421 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381421 [ RunTime:0.001941s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (380936,386101,496746,268122,7228,506281,551912,555816,316651,617024,498708,129266,23382,679833,382753,555460,788184,187840,597358,669004,66604,507654,619966,518887,277273,452088,275092,775399,190176,449076,654128,44178,560121,349561,1010077,973854,391906,349294,654655,28339,223026,301660,559280,362929,724266,472738,639232,90579,879302,270693,659834,479563,882027,312580,111884,460339,553553,467716,896362,528190) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000690s ]