SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001853s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501847 LIMIT 1 [ RunTime:0.000655s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501847 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (60292,383452,721022,369701,898230,759889,777142,303395,889237,651419,734523,279788,437068,1045332,368210,274438,855075,888405,12380,27935,537350,373821,839519,917559,112529,497290,186789,141309,108005,319406,869657,128169,980289,151574,422376,934027,739850,988143,347987,629355,281119,363371,1001576,759809,330625,366724,640703,22642,685258,738824,21462,690309,760975,938032,805658,70288,850389,252902,223042,21513) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501847 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501847 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000395s ]