SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542860 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542860 [ RunTime:0.001961s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (675859,749212,1005312,741406,611083,297642,72543,200252,89842,464126,251397,439800,1041111,5106,973955,847785,60813,1024259,222236,77542,229719,494773,990651,697238,929361,921892,845305,587033,344032,819775,484197,562952,909991,922748,803536,765961,470124,53719,825589,825557,566524,735208,743148,477237,837363,808248,329344,611668,861865,120137,128234,790843,177258,497034,494575,281119,405977,836144,193128,310465) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]