SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802844 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802844 [ RunTime:0.001665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (114941,80827,868147,400122,444579,762330,282198,228175,276099,452995,881130,267047,691136,842774,170638,692641,777419,851231,640135,162885,925820,492015,263266,720778,871150,470593,69415,1043536,502251,855643,705860,125744,395538,788923,669948,751475,1027293,538984,421252,286995,1003216,415455,520648,1010086,246160,567087,928306,561577,60760,917929,159246,122599,943894,1032105,686484,579035,791709,793842,791440,1014024) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802844 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802844 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]