SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421613 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421613 [ RunTime:0.001782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470788,593732,537879,431237,616899,1030294,677854,440428,574847,64204,992966,931444,283506,502945,735223,657567,643593,370595,654791,363208,719860,233976,429300,860860,338082,148821,434977,936276,430850,563431,973343,6882,640882,666168,938666,865027,126599,908877,833659,642228,367183,53102,372711,766801,585010,713744,404468,907043,41101,838285,971260,869273,595918,869829,692812,976880,983413,929601,175678,750789) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000609s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]